object DM: TDM
  OldCreateOrder = False
  Height = 539
  Width = 511
  object MysqlConnection: TUniConnection
    ProviderName = 'MySQL'
    Port = 3306
    Database = 'gzdb'
    Username = 'root'
    Server = 'localhost'
    LoginPrompt = False
    Left = 64
    Top = 80
  end
  object MySQLUniProvider1: TMySQLUniProvider
    Left = 56
    Top = 16
  end
  object DSReestr: TDataSource
    DataSet = UniQueryReestr
    Left = 56
    Top = 200
  end
  object UniTableSearch: TUniTable
    TableName = 'reestr'
    Connection = MysqlConnection
    CachedUpdates = True
    AutoCalcFields = False
    FilterOptions = [foCaseInsensitive]
    AfterOpen = UniTableSearchAfterOpen
    Options.TrimFixedChar = False
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.StrictUpdate = False
    Options.LongStrings = False
    Options.RemoveOnRefresh = False
    Left = 180
    Top = 268
    object UniTableSearchid: TIntegerField
      AutoGenerateValue = arAutoInc
      FieldName = 'id'
    end
    object UniTableSearchgoszakup_id: TIntegerField
      FieldName = 'goszakup_id'
      Required = True
    end
    object UniTableSearchname: TStringField
      FieldName = 'name'
      Size = 250
    end
    object UniTableSearchdate_reg: TStringField
      FieldName = 'date_reg'
    end
    object UniTableSearchdate_lastupdate: TStringField
      FieldName = 'date_lastupdate'
    end
    object UniTableSearchrole: TStringField
      FieldName = 'role'
      Size = 250
    end
    object UniTableSearchgos_reest_zak: TStringField
      FieldName = 'gos_reest_zak'
      Size = 250
    end
    object UniTableSearchrnn: TStringField
      FieldName = 'rnn'
    end
    object UniTableSearchbin: TStringField
      FieldName = 'bin'
    end
    object UniTableSearchiin: TStringField
      FieldName = 'iin'
    end
    object UniTableSearchname_kazakh: TStringField
      FieldName = 'name_kazakh'
      Size = 250
    end
    object UniTableSearchname_russian: TStringField
      FieldName = 'name_russian'
      Size = 250
    end
    object UniTableSearchresident: TStringField
      FieldName = 'resident'
      Size = 250
    end
    object UniTableSearchkato: TStringField
      FieldName = 'kato'
    end
    object UniTableSearchregion: TStringField
      FieldName = 'region'
      Size = 250
    end
    object UniTableSearchgos_reg_num: TStringField
      FieldName = 'gos_reg_num'
    end
    object UniTableSearchgos_reg_date: TStringField
      FieldName = 'gos_reg_date'
    end
    object UniTableSearchreport_admin_name: TStringField
      FieldName = 'report_admin_name'
      Size = 250
    end
    object UniTableSearchkopf: TStringField
      FieldName = 'kopf'
      Size = 250
    end
    object UniTableSearchkfc: TStringField
      FieldName = 'kfc'
      Size = 250
    end
    object UniTableSearchorgan_size: TStringField
      FieldName = 'organ_size'
      Size = 250
    end
    object UniTableSearchsector_code: TStringField
      FieldName = 'sector_code'
      Size = 250
    end
    object UniTableSearchotmetka: TStringField
      FieldName = 'otmetka'
      Size = 250
    end
    object UniTableSearchchief_name: TStringField
      FieldName = 'chief_name'
      Size = 250
    end
    object UniTableSearchchief_iin: TStringField
      FieldName = 'chief_iin'
    end
    object UniTableSearchchief_rnn: TStringField
      FieldName = 'chief_rnn'
    end
    object UniTableSearchchief_employee: TStringField
      FieldName = 'chief_employee'
      Size = 250
    end
    object UniTableSearchemployees_id: TIntegerField
      FieldName = 'employees_id'
    end
    object UniTableSearchcountry: TStringField
      FieldName = 'country'
      Size = 250
    end
    object UniTableSearchadress_fact: TStringField
      FieldName = 'adress_fact'
      Size = 250
    end
    object UniTableSearchadress_jur: TStringField
      FieldName = 'adress_jur'
      Size = 250
    end
    object UniTableSearchphone: TStringField
      FieldKind = fkLookup
      FieldName = 'phone'
      LookupKeyFields = 'goszakup_id'
      LookupResultField = 'employee_phone'
      KeyFields = 'goszakup_id'
      Size = 50
      Lookup = True
    end
    object UniTableSearchemail: TStringField
      FieldKind = fkLookup
      FieldName = 'email'
      LookupKeyFields = 'goszakup_id'
      LookupResultField = 'employee_email'
      KeyFields = 'goszakup_id'
      Size = 50
      Lookup = True
    end
  end
  object DSSearch: TDataSource
    DataSet = UniQuerySearch
    Left = 180
    Top = 332
  end
  object UniTableRep1: TUniTable
    TableName = 'reestr'
    Connection = MysqlConnection
    FilterSQL = 'goszakup_id = 18'
    CachedUpdates = True
    AutoCalcFields = False
    Filtered = True
    FilterOptions = [foCaseInsensitive]
    Left = 304
    Top = 144
    object UniTableRep1id: TIntegerField
      AutoGenerateValue = arAutoInc
      FieldName = 'id'
    end
    object UniTableRep1goszakup_id: TIntegerField
      FieldName = 'goszakup_id'
      Required = True
    end
    object UniTableRep1name: TStringField
      FieldName = 'name'
      Size = 250
    end
    object UniTableRep1date_reg: TStringField
      FieldName = 'date_reg'
    end
    object UniTableRep1date_lastupdate: TStringField
      FieldName = 'date_lastupdate'
    end
    object UniTableRep1role: TStringField
      FieldName = 'role'
      Size = 250
    end
    object UniTableRep1gos_reest_zak: TStringField
      FieldName = 'gos_reest_zak'
      Size = 250
    end
    object UniTableRep1rnn: TStringField
      FieldName = 'rnn'
    end
    object UniTableRep1bin: TStringField
      FieldName = 'bin'
    end
    object UniTableRep1iin: TStringField
      FieldName = 'iin'
    end
    object UniTableRep1name_kazakh: TStringField
      FieldName = 'name_kazakh'
      Size = 250
    end
    object UniTableRep1name_russian: TStringField
      FieldName = 'name_russian'
      Size = 250
    end
    object UniTableRep1resident: TStringField
      FieldName = 'resident'
      Size = 250
    end
    object UniTableRep1kato: TStringField
      FieldName = 'kato'
    end
    object UniTableRep1region: TStringField
      FieldName = 'region'
      Size = 250
    end
    object UniTableRep1gos_reg_num: TStringField
      FieldName = 'gos_reg_num'
    end
    object UniTableRep1gos_reg_date: TStringField
      FieldName = 'gos_reg_date'
    end
    object UniTableRep1report_admin_name: TStringField
      FieldName = 'report_admin_name'
      Size = 250
    end
    object UniTableRep1kopf: TStringField
      FieldName = 'kopf'
      Size = 250
    end
    object UniTableRep1kfc: TStringField
      FieldName = 'kfc'
      Size = 250
    end
    object UniTableRep1organ_size: TStringField
      FieldName = 'organ_size'
      Size = 250
    end
    object UniTableRep1sector_code: TStringField
      FieldName = 'sector_code'
      Size = 250
    end
    object UniTableRep1otmetka: TStringField
      FieldName = 'otmetka'
      Size = 250
    end
    object UniTableRep1chief_name: TStringField
      FieldName = 'chief_name'
      Size = 250
    end
    object UniTableRep1chief_iin: TStringField
      FieldName = 'chief_iin'
    end
    object UniTableRep1chief_rnn: TStringField
      FieldName = 'chief_rnn'
    end
    object UniTableRep1chief_employee: TStringField
      FieldName = 'chief_employee'
      Size = 250
    end
    object UniTableRep1employees_id: TIntegerField
      FieldName = 'employees_id'
    end
    object UniTableRep1country: TStringField
      FieldName = 'country'
      Size = 250
    end
    object UniTableRep1adress_fact: TStringField
      FieldName = 'adress_fact'
      Size = 250
    end
    object UniTableRep1adress_jur: TStringField
      FieldName = 'adress_jur'
      Size = 250
    end
  end
  object UniTransaction1: TUniTransaction
    DefaultConnection = MysqlConnection
    Left = 272
    Top = 308
  end
  object UniQueryReestr: TUniQuery
    Connection = MysqlConnection
    ParamCheck = False
    SQL.Strings = (
      'SELECT reestr.*, employees.employee_email'
      '  FROM gzdb.employees employees, gzdb.reestr reestr'
      ' WHERE reestr.goszakup_id = employees.goszakup_id '
      'limit 0, 50')
    FetchRows = 150
    ReadOnly = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.StrictUpdate = False
    Options.RemoveOnRefresh = False
    Options.UpdateBatchSize = 0
    AutoCalcFields = False
    FilterOptions = [foCaseInsensitive]
    AfterOpen = UniQueryReestrAfterOpen
    Left = 60
    Top = 296
  end
  object UniQuerySearch: TUniQuery
    Connection = MysqlConnection
    ParamCheck = False
    SQL.Strings = (
      'SELECT reestr.*, employees.employee_email'
      '  FROM gzdb.employees employees, gzdb.reestr reestr'
      ' WHERE reestr.goszakup_id = employees.goszakup_id '
      'limit 0, 50')
    FetchRows = 150
    ReadOnly = True
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.StrictUpdate = False
    Options.RemoveOnRefresh = False
    Options.UpdateBatchSize = 0
    AutoCalcFields = False
    FilterOptions = [foCaseInsensitive]
    AfterOpen = UniQueryReestrAfterOpen
    Left = 64
    Top = 372
  end
  object UniQueryDetail: TUniQuery
    Connection = MysqlConnection
    ParamCheck = False
    SQL.Strings = (
      'SELECT reestr.*, employees.employee_email'
      '  FROM gzdb.employees employees, gzdb.reestr reestr'
      ' WHERE reestr.goszakup_id = employees.goszakup_id '
      'limit 0, 50')
    FetchRows = 150
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.StrictUpdate = False
    Options.RemoveOnRefresh = False
    Options.UpdateBatchSize = 0
    AutoCalcFields = False
    FilterOptions = [foCaseInsensitive]
    AfterOpen = UniQueryReestrAfterOpen
    Left = 64
    Top = 444
    object IntegerField4: TIntegerField
      AutoGenerateValue = arAutoInc
      FieldName = 'id'
    end
    object IntegerField5: TIntegerField
      FieldName = 'goszakup_id'
      Required = True
    end
    object StringField30: TStringField
      FieldName = 'name'
      Size = 250
    end
    object StringField31: TStringField
      FieldName = 'date_reg'
    end
    object StringField32: TStringField
      FieldName = 'date_lastupdate'
    end
    object StringField33: TStringField
      FieldName = 'role'
      Size = 250
    end
    object StringField34: TStringField
      FieldName = 'gos_reest_zak'
      Size = 250
    end
    object StringField35: TStringField
      FieldName = 'rnn'
    end
    object StringField36: TStringField
      FieldName = 'bin'
    end
    object StringField37: TStringField
      FieldName = 'iin'
    end
    object StringField38: TStringField
      FieldName = 'name_kazakh'
      Size = 250
    end
    object StringField39: TStringField
      FieldName = 'name_russian'
      Size = 250
    end
    object StringField40: TStringField
      FieldName = 'resident'
      Size = 250
    end
    object StringField41: TStringField
      FieldName = 'kato'
    end
    object StringField42: TStringField
      FieldName = 'region'
      Size = 250
    end
    object StringField43: TStringField
      FieldName = 'gos_reg_num'
    end
    object StringField44: TStringField
      FieldName = 'gos_reg_date'
    end
    object StringField45: TStringField
      FieldName = 'report_admin_name'
      Size = 250
    end
    object StringField46: TStringField
      FieldName = 'kopf'
      Size = 250
    end
    object StringField47: TStringField
      FieldName = 'kfc'
      Size = 250
    end
    object StringField48: TStringField
      FieldName = 'organ_size'
      Size = 250
    end
    object StringField49: TStringField
      FieldName = 'sector_code'
      Size = 250
    end
    object StringField50: TStringField
      FieldName = 'otmetka'
      Size = 250
    end
    object StringField51: TStringField
      FieldName = 'chief_name'
      Size = 250
    end
    object StringField52: TStringField
      FieldName = 'chief_iin'
    end
    object StringField53: TStringField
      FieldName = 'chief_rnn'
    end
    object StringField54: TStringField
      FieldName = 'chief_employee'
      Size = 250
    end
    object IntegerField6: TIntegerField
      FieldName = 'employees_id'
    end
    object StringField55: TStringField
      FieldName = 'country'
      Size = 250
    end
    object StringField56: TStringField
      FieldName = 'adress_fact'
      Size = 250
    end
    object StringField57: TStringField
      FieldName = 'adress_jur'
      Size = 250
    end
    object StringField58: TStringField
      FieldName = 'employee_email'
      ReadOnly = True
      Size = 250
    end
  end
  object DataSourceDetail: TDataSource
    DataSet = UniQueryDetail
    Left = 204
    Top = 440
  end
  object UniTableEmail: TUniTable
    TableName = 'employees'
    Connection = MysqlConnection
    CachedUpdates = True
    AutoCalcFields = False
    FilterOptions = [foCaseInsensitive]
    Options.TrimFixedChar = False
    Options.SetFieldsReadOnly = False
    Options.RequiredFields = False
    Options.StrictUpdate = False
    Options.LongStrings = False
    Options.RemoveOnRefresh = False
    Options.CacheCalcFields = True
    Left = 168
    Top = 144
  end
end
